from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String

Base = declarative_base()


class BaseMachine(Base):
    __tablename__ = 'base_machine'

    tid = Column(Integer, primary_key=True)
    machine_no = Column(String)
    machine_ip = Column(String)
    factory_no = Column(String)
    workshop_no = Column(String)
    workshop_area = Column(String)
    spindle_count = Column(Integer)
    spindle_mode = Column(Integer)
    standard_spindle_speed = Column(Integer)
    front_roller_speed = Column(Integer)
    standard_twist = Column(Integer)
    rear_roller_speed = Column(Integer)
    dtime = Column(String)
    uploaded = Column(Integer)
    upload_time = Column(String)